package com.x.mapper;

import com.x.pojo.Employee;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

/**
 * ClassName: empMapper
 * Package: IntelliJ IDEA
 * Description:
 * Written by HanXu
 * Create 2024.09.06 18:39
 */
public interface empMapper {


    List<Employee> queryBySalary(Double salary);

    //根据姓名与工资查员工
    List<Employee> queryByNameAndSalary(@Param("name") String name, @Param("salary") Double salary);


    //插入员工数据，不能重载
    //map(name=员工名字, salary=员工工资)
    int insertEmpMap(Map<String, Object> map);


    int deleteById(Integer empId);
    String queryNameById(Integer empId);
    Double querySalaryById(Integer empId);


    //返回工资最高的员工的姓名和他的工资
    Map<String, Object> selectEmpNameAndMaxSalary();

    //返回工资大于某某数值的员工集合
    List<String> queryNameOutSalary(@Param("salary") Double salary);

    //插入员工数据
    int insertEmp(Employee employee);

    int insertEmpUid(Employee employee);

    Employee queryById(int empId);



}
